2013-03-22 - 5910.200 - Rel Notes - Contracts - Release 009 #BIReleases2013

Release Notes:

5910.200 - Contracts - SA231


Admin Info

Purpose
 Including Contract Information in SA231 report
Release No
 009
Submitted
 03-22-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Narendra K
Object(s) Tested By
 Narendra K

Report Name

SA231 - MLB Sales Analysis by Material Group and Region

BEx Query

ZMP_OPASA_Q019

NEC Crystal Reports Standards Check

1. SA231 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA231 NEC CR checklist has been sent to NEC and also attached here for reference.

SA231 NEC CR Standard Check List.xlsx

Summary Level Check

Test Conducted

Report Header
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,491,495
 1,491,495
 Pass
2
 Ship Rev
 15,543,149
 15,543,149
 Pass
3
 Open Qty
 1,880
 1,880
 Pass
4
 Open Rev
 17,038
 17,038
 Pass
5
 Cost
 6,681,349
 6,681,349
 Pass
6
 Comm
 462,040
 462,040
 Pass
7
 Royalty
 2,468,356
 2,468,356
 Pass
8
 Contrib
 6,023,410
 6,023,410
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 2,786,803
 2,786,803
 Pass
2
 Ship Rev
 32,463,148
 32,463,148
 Pass
3
 Open Qty
 498,465
 498,465
 Pass
4
 Open Rev
 6,228,477
 6,228,477
 Pass
5
 Cost
 13,801,680
 13,801,680
 Pass
6
 Comm
 756,929
 756,929
 Pass
7
 Royalty
 5,143,739
 5,143,739
 Pass
8
 Contrib
 13,139,682
 13,139,682
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 904,672
 904,672
 Pass
2
 Ship Rev
 10,929,907
 10,929,907
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 3,543,017
 3,543,017
 Pass
6
 Comm
 384,956
 384,956
 Pass
7
 Royalty
 1,874,773
 1,874,773
 Pass
8
 Contrib
 5,127,162
 5,127,162
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 2,832,401
 2,832,401
 Pass
2
 Ship Rev
 38,686,407
 38,686,407
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 11,455,309
 11,455,309
 Pass
6
 Comm
 965,352
 965,352
 Pass
7
 Royalty
 6,529,934
 6,529,934
 Pass
8
 Contrib
 19,735,813
 19,735,813
 Pass

Second Level Check

Grouping: Material Group > Region

Test Conducted

Group: Headwear
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,107,888
 1,107,888
 Pass
2
 Ship Rev
 12,477,328
 12,477,328
 Pass
3
 Open Qty
 1,880
 1,880
 Pass
4
 Open Rev
 17,038
 17,038
 Pass
5
 Cost
 4,264,010
 4,264,010
 Pass
6
 Comm
 413,773
 413,773
 Pass
7
 Royalty
 2,109,566
 2,109,566
 Pass
8
 Contrib
 5,689,978
 5,689,978
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,962,279
 1,962,279
 Pass
2
 Ship Rev
 26,054,889
 26,054,889
 Pass
3
 Open Qty
 382,303
 382,303
 Pass
4
 Open Rev
 4,978,981
 4,978,981
 Pass
5
 Cost
 7,661,464
 7,661,464
 Pass
6
 Comm
 657,875
 657,875
 Pass
7
 Royalty
 4,532,135
 4,532,135
 Pass
8
 Contrib
 13,383,414
 13,383,414
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 904,672
 904,672
 Pass
2
 Ship Rev
 10,929,907
 10,929,907
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 3,543,017
 3,543,017
 Pass
6
 Comm
 384,956
 384,956
 Pass
7
 Royalty
 1,874,773
 1,874,773
 Pass
8
 Contrib
 5,127,162
 5,127,162
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 2,826,091
 2,826,091
 Pass
2
 Ship Rev
 38,606,487
 38,606,487
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 11,407,465
 11,407,465
 Pass
6
 Comm
 963,760
 963,760
 Pass
7
 Royalty
 6,529,717
 6,529,717
 Pass
8
 Contrib
 19,705,545
 19,705,545
 Pass

Third Level Check

Grouping: Material Group > Region

Test Conducted

Group: Headwear > North America
Year 2013
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 706,802
 706,802
 Pass
2
 Ship Rev
 8,225,175
 8,225,175
 Pass
3
 Open Qty
 1,838
 1,838
 Pass
4
 Open Rev
 16,440
 16,440
 Pass
5
 Cost
 2,818,870
 2,818,870
 Pass
6
 Comm
 335,580
 335,580
 Pass
7
 Royalty
 1,363,580
 1,363,580
 Pass
8
 Contrib
 3,707,117
 3,707,117
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 1,659,215
 1,659,215
 Pass
2
 Ship Rev
 21,929,047
 21,929,047
 Pass
3
 Open Qty
 188,671
 188,671
 Pass
4
 Open Rev
 2,393,685
 2,393,685
 Pass
5
 Cost
 6,647,297
 6,647,297
 Pass
6
 Comm
 570,505
 570,505
 Pass
7
 Royalty
 3,667,239
 3,667,239
 Pass
8
 Contrib
 11,044,006
 11,044,006
 Pass

Year 2012
Period - January
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 761,572
 761,572
 Pass
2
 Ship Rev
 9,025,620
 9,025,620
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 3,035,721
 3,035,721
 Pass
6
 Comm
 357,319
 357,319
 Pass
7
 Royalty
 1,540,248
 1,540,248
 Pass
8
 Contrib
 4,092,331
 4,092,331
 Pass
Period - March
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Ship Qty
 2,396,601
 2,396,601
 Pass
2
 Ship Rev
 32,845,048
 32,845,048
 Pass
3
 Open Qty
 0
 0
 Pass
4
 Open Rev
 0
 0
 Pass
5
 Cost
 9,892,482
 9,892,482
 Pass
6
 Comm
 847,930
 847,930
 Pass
7
 Royalty
 5,526,353
 5,526,353
 Pass
8
 Contrib
 16,578,283
 16,578,283
 Pass

Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports